package cj.web.marriage.dao;
/*
 *  
 *  
*/
import java.util.List;

import net.paoding.rose.jade.annotation.DAO;
import net.paoding.rose.jade.annotation.SQL;
import cj.web.marriage.domain.VoteResultsCopy;

/**
 * 
 * @author 
 *
 */
@DAO
public interface VoteResultsCopyDAO{
	
	@SQL("SELECT id,requestIp FROM VoteResultsCopy where address is null ")
	List<VoteResultsCopy> queryAll();
	
	@SQL("SELECT * FROM VoteResultsCopy WHERE id=:1 ")
	VoteResultsCopy queryById(int id);
	
	@SQL("SELECT count(1) FROM VoteResultsCopy ")
    int querySize();
    
    @SQL("UPDATE VoteResultsCopy SET address=:2 WHERE id=:1")
    void updateByVoteId(int id,String address);
}